<%@ page import="cn.edu.njust.service.trService" %>
<%@ page import="cn.edu.njust.service.impl.trServiceImpl" %>
<%@ page import="cn.edu.njust.pojo.Transcipt" %>
<%@ page import="java.util.List" %>
<%@ page import="cn.edu.njust.pojo.User" %>
<%@ page import="cn.edu.njust.service.ResultService" %>
<%@ page import="cn.edu.njust.service.impl.ResultServiceImpl" %>
<%@ page import="cn.edu.njust.pojo.Result" %>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>CCF预报名系统|上传名单</title>

    <!-- Google Font: Source Sans Pro -->
    <link rel="stylesheet"
          href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="./plugins/fontawesome-free/css/all.min.css">
    <!-- DataTables -->
    <link rel="stylesheet" href="./plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="./plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
    <link rel="stylesheet" href="./plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="./dist/css/adminlte.min.css">

    <script src="./js/axios-0.18.0.js"></script>

</head>
<body class="hold-transition sidebar-mini">


<div class="wrapper">
    <nav class="main-header navbar navbar-expand navbar-white navbar-light">
        <!-- Left navbar links -->
        <ul class="navbar-nav">
            <li class="nav-item">
                <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
            </li>
        </ul>

        <!-- Right navbar links -->
        <ul class="navbar-nav ml-auto">
            <li class="nav-item">
                <button type="button" class="btn btn-info" onclick="exitRegister()">退出当前登录</button>
            </li>
            <li class="nav-item">
                <a class="nav-link" data-widget="fullscreen" href="#" role="button">
                    <i class="fas fa-expand-arrows-alt"></i>
                </a>
            </li>
        </ul>
    </nav>
    <!-- /.navbar -->

    <!-- Main Sidebar Container -->
    <aside class="main-sidebar sidebar-dark-primary elevation-4">
        <!-- Brand Logo -->
        <a href="#" class="brand-link">
            <img src="./dist/img/AdminLTELogo.png" alt="CCF预报名系统" class="brand-image img-circle elevation-3"
                 style="opacity: .8">
            <span class="brand-text font-weight-light">CCF预报名系统</span>
        </a>

        <!-- Sidebar -->
        <div class="sidebar">
            <!-- Sidebar Menu -->
            <nav class="mt-2">
                <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu"
                    data-accordion="false">
                    <!-- Add icons to the links using the .nav-icon class
                         with font-awesome or any other icon font library -->
                    <li class="nav-item">
                        <a href="/CCF_Pre_Registration_System/teacherInfo.jsp" class="nav-link">
                            <i class="nav-icon fas fa-eraser"></i>
                            <p>我的信息</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="/CCF_Pre_Registration_System/teacherChangeInfo.jsp" class="nav-link">
                            <i class="nav-icon fas fa-exclamation"></i>
                            <p>修改信息</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="/CCF_Pre_Registration_System/application.jsp" class="nav-link">
                            <i class="nav-icon fas fa-exclamation"></i>
                            <p>报名情况</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="/CCF_Pre_Registration_System/uploading.jsp" class="nav-link">
                            <i class="nav-icon fas fa-exclamation"></i>
                            <p>上传名单</p>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="/CCF_Pre_Registration_System/check.jsp" class="nav-link">
                            <i class="nav-icon fas fa-exclamation"></i>
                            <p>审核资格</p>
                        </a>
                    </li>
                </ul>
            </nav>
            <!-- /.sidebar-menu -->
        </div>
        <!-- /.sidebar -->
    </aside>
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <table id="example1" class="table table-bordered table-hover">
                                    <%
                                        ResultService rs = new ResultServiceImpl();
                                        List<Result> results = rs.selectAllResult();
                                    %>


                                    <thead>
                                    <tr>
                                        <th>学号</th>
                                        <th>成绩单编号</th>
                                        <th>编程语言</th>
                                        <th>参考年份</th>
                                        <th>第一题成绩</th>
                                        <th>第二题成绩</th>
                                        <th>第三题成绩</th>
                                        <th>第四题成绩</th>
                                        <th>第五题成绩</th>
                                        <th>总分</th>
                                    </tr>
                                    </thead>
                                    <tbody>

                                    <%
                                        for (int i = 0; i < results.size(); i++) {
                                            Result result = results.get(i);
                                    %>
                                    <tr>
                                        <td><%=result.getIdNo()%>
                                        </td>
                                        <td><%=result.getReNo()%>
                                        </td>
                                        <td><%=result.getLanguage()%>
                                        </td>
                                        <td><%=result.getYear()%>
                                        </td>
                                        <td><%=result.getQ1_grade()%>
                                        </td>
                                        <td><%=result.getQ2_grade()%>
                                        </td>
                                        <td><%=result.getQ3_grade()%>
                                        </td>
                                        <td><%=result.getQ4_grade()%>
                                        </td>
                                        <td><%=result.getQ5_grade()%>
                                        </td>
                                        <td><%=result.getGrade()%>
                                        </td>

                                    </tr>
                                    <%
                                        }
                                    %>

                                    </tbody>
                                    <tfoot>
                                    <tr>
                                        <th>学号</th>
                                        <th>成绩单编号</th>
                                        <th>编程语言</th>
                                        <th>参考年份</th>
                                        <th>第一题成绩</th>
                                        <th>第二题成绩</th>
                                        <th>第三题成绩</th>
                                        <th>第四题成绩</th>
                                        <th>第五题成绩</th>
                                        <th>总分</th>
                                    </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        <div class="card">
                            <div class="card-body">
                                <form action="javascript:void(0)" method="post" enctype="multipart/form-data">
                                    <input type="file" name="files" id="files"/>
                                    <input type="submit" style="width: 100px;background-color:#e6dddd;" class="up"/>

                                </form>
                                <%--
                                                                <button type="button" class="btn btn-info">上传名单</button>
                                --%>
                            </div>
                        </div>
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->
            </div><!-- /.container-fluid -->
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->
    <footer class="main-footer">
        <div class="float-right d-none d-sm-block">
            <b>Version</b> 1.0.0
        </div>
        <strong>Copyright &copy; 2022 <a href="#">软件项目管理第六小组</a>.</strong> All rights reserved.
    </footer>

    <!-- Control Sidebar -->
    <aside class="control-sidebar control-sidebar-dark">
        <!-- Control sidebar content goes here -->
    </aside>
    <!-- /.control-sidebar -->
</div>
<!-- jQuery -->
<script src="./plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="./plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="./dist/js/adminlte.min.js"></script>
<!-- FLOT CHARTS -->
<script src="./plugins/flot/jquery.flot.js"></script>
<!-- FLOT RESIZE PLUGIN - allows the chart to redraw when the window is resized -->
<script src="./plugins/flot/plugins/jquery.flot.resize.js"></script>
<!-- FLOT PIE PLUGIN - also used to draw donut charts -->
<script src="./plugins/flot/plugins/jquery.flot.pie.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="./dist/js/demo.js"></script>
<!-- DataTables  & Plugins -->
<script src="./plugins/datatables/jquery.dataTables.min.js"></script>
<script src="./plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="./plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="./plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="./plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="./plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="./plugins/jszip/jszip.min.js"></script>
<script src="./plugins/pdfmake/pdfmake.min.js"></script>
<script src="./plugins/pdfmake/vfs_fonts.js"></script>
<script src="./plugins/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="./plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="./plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
<script src="./js/axios-0.18.0.js"></script>
<script>
    $(function () {
        $("#example1").DataTable({
            "responsive": true, "lengthChange": false, "autoWidth": false,
            "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });
    });

    function exitRegister() {
        axios({
            method: "post",
            url: "/CCF_Pre_Registration_System/systemControl/exitCurrentLoginUser"
        }).then(function (resp) {
            if (resp.data === "success") {
                window.location.href = "index.jsp";
            } else {
                alert("请重试");
            }
        })
    }


    var uploadFile = document.querySelector('#files');
    var fileName = '';
    uploadFile.addEventListener("change", function () {
        console.log(uploadFile.files[0].name);
        fileName = uploadFile.files[0].name;
    })

    var upFile = document.querySelector('.up');
    upFile.addEventListener('click', function () {
        var that = this;
        axios({
            method: 'get',
            url: '/CCF_Pre_Registration_System/resultServlet?fileName=' + fileName
        }).then(function (resp) {
            if (resp.data === "success") {
                window.location.href = "uploading.jsp";
            } else {
                alert("上传失败！！！")
            }
        })
    })
</script>

</body>
</html>